Migration of databases to cross-platforms is becoming a necessity these days because of cloud computing and the need for deploying onto hosting company data centers.  The key is using of RMAN’s cross-platform backup and restore technique, an important RMAN feature of Oracle 12c.  When incremental-based backup and restore approach is used, the migration time can…

Have you ever faced a plan performance regression in your Oracle database after a version upgrade? One of your core's production SQLs suddenly changed its execution plan slowing down your application? SQL Plan Management (SPM) 12c is the ultimate plan stability solution to prevent plan performance regressions by giving you the flexibility to tell the CBO…

To recap where Part 1 of this article series ended, we finished using Database Workload Capture to collect two different workloads from an Oracle 11.2.0.3 database — one OLTP workload, and one DSS workload — and saved the resulting shadow capture files for eventual transference to a new platform for Database Workload Replay testing and evaluation.

Apr 21 @  11:00am

This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, IN-Memory and Oracle 19c Automatic Indexing, and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect a brief introduction of all the new…

Many organization struggle to take control of their environment monitoring challenges - especially for databases. Shell scripts and cron jobs are great, but what happens when functionality changes or when a new database version is introduced? How about that one DBA who spent 5 years developing all the scripts and then leaves the company without…

The new release of Oracle Database has come with many new exciting enhancements for the High Availability. The aim of this presentation is to introduce some new DataGuard features through practical examples. Among various enhancements, special attention will be given to the new Far Sync Instance and the Real-Time Cascade Standby. Whitepaper PowerPoint

Thursday, May 28, 2015 - Extreme Database Performance Whether it's for upgrading to Database 12c, or looking at what the combination of Engineered Systems and the most recent release of the database can do together, the term "extreme performance" is constantly referenced. But what makes it extreme, and what does that mean to you? Join…

Using corrective actions in Cloud Control 12c we can automate resolutions for alerts. This paper outlines how to configure and setup corrective actions. In the example for this paper we will show how to setup corrective action for archive area used % and what the corrective action should execute when the warning threshold is hit.…

Many organization struggle to take control of their environment monitoring challenges - especially for databases. Shell scripts and cron jobs are great, but what happens when functionality changes or when a new database version is introduced? How about that one DBA who spent 5 years developing all the scripts and then leaves the company without…